﻿
GO
IF NOT EXISTS (SELECT Name FROM ClaimType WHERE Name = 'Create' AND ApplicationId = 1)
BEGIN
INSERT INTO ClaimType(Name,ApplicationId,Uri)
     VALUES('Create',1,'http://schemas.palisha.com/2012/10/identity/claims/create')
END

GO
IF NOT EXISTS (SELECT Name FROM ClaimType WHERE Name = 'Read' AND ApplicationId = 1)
BEGIN
INSERT INTO ClaimType(Name,ApplicationId,Uri)
     VALUES('Read',1,'http://schemas.palisha.com/2012/10/identity/claims/read')
END

GO
IF NOT EXISTS (SELECT Name FROM ClaimType WHERE Name = 'Update' AND ApplicationId = 1)
BEGIN
INSERT INTO ClaimType(Name,ApplicationId,Uri)
     VALUES('Update',1,'http://schemas.palisha.com/2012/10/identity/claims/update')
END

GO
IF NOT EXISTS (SELECT Name FROM ClaimType WHERE Name = 'Delete' AND ApplicationId = 1)
BEGIN
INSERT INTO ClaimType(Name,ApplicationId,Uri)
     VALUES('Delete',1,'http://schemas.palisha.com/2012/10/identity/claims/delete')
END


GO
IF NOT EXISTS (SELECT Name FROM ClaimType WHERE Name = 'View' AND ApplicationId = 1)
BEGIN
INSERT INTO ClaimType(Name,ApplicationId,Uri)
     VALUES('View',1,'http://schemas.palisha.com/2012/10/identity/claims/view')
END